--*-----------------------------------------------------------------------------
--
-- SetOptionInt
--
--*-----------------------------------------------------------------------------
IF EXISTS (
  SELECT 1 FROM sys.objects
   WHERE type = 'P'
     AND schema_id = SCHEMA_ID('dbo')
     AND name = 'SetOptionInt'
)
DROP PROCEDURE SetOptionInt
GO
--*-----------------------------------------------------------------------------
CREATE PROCEDURE SetOptionInt(@key_str VARCHAR(50), @value_int INT)
AS
BEGIN
  UPDATE site_option
     SET value_int = @value_int
   WHERE name = @key_str
END
GO